Overview
Brought to you by YData
Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 28236 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 12.4 MiB |
| Average record size in memory | 462.0 B |
Variable types
| Text | 2 |
|---|---|
| DateTime | 1 |
| Categorical | 6 |
| Numeric | 12 |
| Boolean | 3 |
post_hour has constant value "9" | Constant |
caption_length is highly overall correlated with long_caption | High correlation |
engagement_rate is highly overall correlated with followers_count_before_post and 1 other fields | High correlation |
follower_bucket is highly overall correlated with followers_count_before_post | High correlation |
followers_count_before_post is highly overall correlated with engagement_rate and 1 other fields | High correlation |
has_high_hashtags is highly overall correlated with hashtags_count | High correlation |
hashtags_count is highly overall correlated with has_high_hashtags | High correlation |
high_intent_engagement is highly overall correlated with saves | High correlation |
impressions is highly overall correlated with reach | High correlation |
is_weekend is highly overall correlated with post_day | High correlation |
likes is highly overall correlated with engagement_rate | High correlation |
long_caption is highly overall correlated with caption_length | High correlation |
post_day is highly overall correlated with is_weekend | High correlation |
reach is highly overall correlated with impressions | High correlation |
saves is highly overall correlated with high_intent_engagement | High correlation |
long_caption is highly imbalanced (63.9%) | Imbalance |
follower_bucket is uniformly distributed | Uniform |
post_id has unique values | Unique |
hashtags_count has 957 (3.4%) zeros | Zeros |
Reproduction
| Analysis started | 2025-12-27 13:04:01.486163 |
|---|---|
| Analysis finished | 2025-12-27 13:04:20.435753 |
| Duration | 18.95 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
post_id
Text
Unique 
| Distinct | 28236 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 28236 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | IG0013402 |
|---|---|
| 2nd row | IG0010751 |
| 3rd row | IG0013361 |
| 4th row | IG0027034 |
| 5th row | IG0022212 |
| Value | Count | Frequency (%) |
| ig0013402 | 1 | < 0.1% |
| ig0011970 | 1 | < 0.1% |
| ig0022212 | 1 | < 0.1% |
| ig0027062 | 1 | < 0.1% |
| ig0021589 | 1 | < 0.1% |
| ig0012768 | 1 | < 0.1% |
| ig0000281 | 1 | < 0.1% |
| ig0013175 | 1 | < 0.1% |
| ig0000512 | 1 | < 0.1% |
| ig0021320 | 1 | < 0.1% |
| Other values (28226) | 28226 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 77131 | |
| I | 28236 | 11.1% |
| G | 28236 | 11.1% |
| 2 | 20749 | 8.2% |
| 1 | 20711 | 8.1% |
| 5 | 11315 | 4.5% |
| 6 | 11313 | 4.5% |
| 9 | 11293 | 4.4% |
| 4 | 11289 | 4.4% |
| 8 | 11286 | 4.4% |
| Other values (2) | 22565 | 8.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 197652 | |
| Uppercase Letter | 56472 | 22.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 77131 | |
| 2 | 20749 | 10.5% |
| 1 | 20711 | 10.5% |
| 5 | 11315 | 5.7% |
| 6 | 11313 | 5.7% |
| 9 | 11293 | 5.7% |
| 4 | 11289 | 5.7% |
| 8 | 11286 | 5.7% |
| 3 | 11283 | 5.7% |
| 7 | 11282 | 5.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 28236 | |
| G | 28236 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 197652 | |
| Latin | 56472 | 22.2% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 77131 | |
| 2 | 20749 | 10.5% |
| 1 | 20711 | 10.5% |
| 5 | 11315 | 5.7% |
| 6 | 11313 | 5.7% |
| 9 | 11293 | 5.7% |
| 4 | 11289 | 5.7% |
| 8 | 11286 | 5.7% |
| 3 | 11283 | 5.7% |
| 7 | 11282 | 5.7% |
Latin
| Value | Count | Frequency (%) |
| I | 28236 | |
| G | 28236 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 254124 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 77131 | |
| I | 28236 | 11.1% |
| G | 28236 | 11.1% |
| 2 | 20749 | 8.2% |
| 1 | 20711 | 8.1% |
| 5 | 11315 | 4.5% |
| 6 | 11313 | 4.5% |
| 9 | 11293 | 4.4% |
| 4 | 11289 | 4.4% |
| 8 | 11286 | 4.4% |
| Other values (2) | 22565 | 8.9% |
upload_date
Date
| Distinct | 366 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 441.2 KiB |
| Minimum | 2024-11-19 09:25:22.954916 |
|---|---|
| Maximum | 2025-11-19 09:25:22.954916 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
media_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| Reel | |
|---|---|
| Carousel | |
| Video | |
| Photo |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 5.5015229 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Reel |
|---|---|
| 2nd row | Video |
| 3rd row | Video |
| 4th row | Video |
| 5th row | Carousel |
Common Values
| Value | Count | Frequency (%) |
| Reel | 7085 | |
| Carousel | 7082 | |
| Video | 7062 | |
| Photo | 7007 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| reel | 7085 | |
| carousel | 7082 | |
| video | 7062 | |
| photo | 7007 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 28314 | |
| o | 28158 | |
| l | 14167 | |
| R | 7085 | 4.6% |
| C | 7082 | 4.6% |
| a | 7082 | 4.6% |
| r | 7082 | 4.6% |
| u | 7082 | 4.6% |
| s | 7082 | 4.6% |
| V | 7062 | 4.5% |
| Other values (5) | 35145 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 127105 | |
| Uppercase Letter | 28236 | 18.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 28314 | |
| o | 28158 | |
| l | 14167 | |
| a | 7082 | 5.6% |
| r | 7082 | 5.6% |
| u | 7082 | 5.6% |
| s | 7082 | 5.6% |
| i | 7062 | 5.6% |
| d | 7062 | 5.6% |
| h | 7007 | 5.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 7085 | |
| C | 7082 | |
| V | 7062 | |
| P | 7007 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 155341 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 28314 | |
| o | 28158 | |
| l | 14167 | |
| R | 7085 | 4.6% |
| C | 7082 | 4.6% |
| a | 7082 | 4.6% |
| r | 7082 | 4.6% |
| u | 7082 | 4.6% |
| s | 7082 | 4.6% |
| V | 7062 | 4.5% |
| Other values (5) | 35145 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 155341 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 28314 | |
| o | 28158 | |
| l | 14167 | |
| R | 7085 | 4.6% |
| C | 7082 | 4.6% |
| a | 7082 | 4.6% |
| r | 7082 | 4.6% |
| u | 7082 | 4.6% |
| s | 7082 | 4.6% |
| V | 7062 | 4.5% |
| Other values (5) | 35145 |
likes
Real number (ℝ)
High correlation 
| Distinct | 26335 |
|---|---|
| Distinct (%) | 93.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98181.831 |
| Minimum | 7 |
|---|---|
| Maximum | 200000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 9485.5 |
| Q1 | 48112.25 |
| median | 96940.5 |
| Q3 | 147928.75 |
| 95-th percentile | 189716.5 |
| Maximum | 200000 |
| Range | 199993 |
| Interquartile range (IQR) | 99816.5 |
Descriptive statistics
| Standard deviation | 57878.895 |
|---|---|
| Coefficient of variation (CV) | 0.58950719 |
| Kurtosis | -1.1981412 |
| Mean | 98181.831 |
| Median Absolute Deviation (MAD) | 49814.5 |
| Skewness | 0.048168889 |
| Sum | 2.7722622 × 109 |
| Variance | 3.3499665 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 82010 | 4 | < 0.1% |
| 194623 | 4 | < 0.1% |
| 61217 | 4 | < 0.1% |
| 86010 | 4 | < 0.1% |
| 18648 | 4 | < 0.1% |
| 97189 | 4 | < 0.1% |
| 4149 | 4 | < 0.1% |
| 31311 | 3 | < 0.1% |
| 60271 | 3 | < 0.1% |
| 29919 | 3 | < 0.1% |
| Other values (26325) | 28199 |
| Value | Count | Frequency (%) |
| 7 | 1 | |
| 9 | 2 | |
| 42 | 1 | |
| 53 | 1 | |
| 66 | 1 | |
| 67 | 1 | |
| 77 | 1 | |
| 95 | 1 | |
| 104 | 1 | |
| 108 | 1 |
| Value | Count | Frequency (%) |
| 200000 | 1 | |
| 199994 | 1 | |
| 199980 | 1 | |
| 199979 | 1 | |
| 199973 | 1 | |
| 199961 | 1 | |
| 199960 | 1 | |
| 199957 | 1 | |
| 199953 | 1 | |
| 199952 | 1 |
comments
Real number (ℝ)
| Distinct | 9416 |
|---|---|
| Distinct (%) | 33.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5014.3199 |
| Minimum | 0 |
|---|---|
| Maximum | 10000 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 2522.75 |
| median | 5035 |
| Q3 | 7520 |
| 95-th percentile | 9499.25 |
| Maximum | 10000 |
| Range | 10000 |
| Interquartile range (IQR) | 4997.25 |
Descriptive statistics
| Standard deviation | 2890.6387 |
|---|---|
| Coefficient of variation (CV) | 0.57647672 |
| Kurtosis | -1.2021642 |
| Mean | 5014.3199 |
| Median Absolute Deviation (MAD) | 2497 |
| Skewness | -0.0078979804 |
| Sum | 1.4158434 × 108 |
| Variance | 8355791.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8617 | 10 | < 0.1% |
| 2643 | 9 | < 0.1% |
| 1458 | 9 | < 0.1% |
| 1961 | 9 | < 0.1% |
| 2990 | 9 | < 0.1% |
| 5857 | 9 | < 0.1% |
| 4407 | 9 | < 0.1% |
| 2982 | 9 | < 0.1% |
| 4888 | 9 | < 0.1% |
| 6357 | 9 | < 0.1% |
| Other values (9406) | 28145 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 1 | 2 | < 0.1% |
| 2 | 3 | |
| 3 | 3 | |
| 4 | 2 | < 0.1% |
| 5 | 5 | |
| 6 | 5 | |
| 7 | 1 | < 0.1% |
| 8 | 3 | |
| 9 | 3 |
| Value | Count | Frequency (%) |
| 10000 | 2 | < 0.1% |
| 9999 | 4 | |
| 9998 | 5 | |
| 9997 | 2 | < 0.1% |
| 9996 | 2 | < 0.1% |
| 9993 | 1 | < 0.1% |
| 9992 | 3 | |
| 9990 | 3 | |
| 9989 | 3 | |
| 9988 | 2 | < 0.1% |
shares
Real number (ℝ)
| Distinct | 4986 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2499.0101 |
| Minimum | 0 |
|---|---|
| Maximum | 5000 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 253 |
| Q1 | 1242 |
| median | 2492 |
| Q3 | 3765.25 |
| 95-th percentile | 4757.25 |
| Maximum | 5000 |
| Range | 5000 |
| Interquartile range (IQR) | 2523.25 |
Descriptive statistics
| Standard deviation | 1448.8879 |
|---|---|
| Coefficient of variation (CV) | 0.57978475 |
| Kurtosis | -1.2132385 |
| Mean | 2499.0101 |
| Median Absolute Deviation (MAD) | 1259.5 |
| Skewness | 0.0085271807 |
| Sum | 70562048 |
| Variance | 2099276.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4820 | 16 | 0.1% |
| 1444 | 16 | 0.1% |
| 4520 | 15 | 0.1% |
| 714 | 15 | 0.1% |
| 823 | 14 | < 0.1% |
| 433 | 14 | < 0.1% |
| 558 | 14 | < 0.1% |
| 3932 | 14 | < 0.1% |
| 309 | 14 | < 0.1% |
| 3675 | 13 | < 0.1% |
| Other values (4976) | 28091 |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1 | 5 | |
| 2 | 3 | < 0.1% |
| 3 | 4 | |
| 4 | 8 | |
| 5 | 8 | |
| 6 | 9 | |
| 7 | 3 | < 0.1% |
| 8 | 4 | |
| 9 | 6 |
| Value | Count | Frequency (%) |
| 5000 | 9 | |
| 4999 | 8 | |
| 4998 | 10 | |
| 4997 | 4 | < 0.1% |
| 4996 | 11 | |
| 4995 | 5 | |
| 4994 | 5 | |
| 4993 | 8 | |
| 4992 | 4 | < 0.1% |
| 4991 | 9 |
saves
Real number (ℝ)
High correlation 
| Distinct | 12667 |
|---|---|
| Distinct (%) | 44.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7478.1542 |
| Minimum | 0 |
|---|---|
| Maximum | 15000 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 746.5 |
| Q1 | 3671.75 |
| median | 7467 |
| Q3 | 11282.25 |
| 95-th percentile | 14236.5 |
| Maximum | 15000 |
| Range | 15000 |
| Interquartile range (IQR) | 7610.5 |
Descriptive statistics
| Standard deviation | 4353.7352 |
|---|---|
| Coefficient of variation (CV) | 0.58219383 |
| Kurtosis | -1.2199524 |
| Mean | 7478.1542 |
| Median Absolute Deviation (MAD) | 3804 |
| Skewness | 0.0063909675 |
| Sum | 2.1115316 × 108 |
| Variance | 18955010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12676 | 9 | < 0.1% |
| 5574 | 8 | < 0.1% |
| 6181 | 8 | < 0.1% |
| 11330 | 8 | < 0.1% |
| 926 | 8 | < 0.1% |
| 13887 | 8 | < 0.1% |
| 10035 | 8 | < 0.1% |
| 6103 | 7 | < 0.1% |
| 3385 | 7 | < 0.1% |
| 1789 | 7 | < 0.1% |
| Other values (12657) | 28158 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 2 | |
| 4 | 4 | |
| 5 | 1 | < 0.1% |
| 6 | 2 | |
| 7 | 2 | |
| 8 | 2 | |
| 9 | 4 |
| Value | Count | Frequency (%) |
| 15000 | 2 | |
| 14999 | 4 | |
| 14998 | 2 | |
| 14997 | 2 | |
| 14996 | 3 | |
| 14995 | 2 | |
| 14994 | 2 | |
| 14993 | 1 | < 0.1% |
| 14992 | 4 | |
| 14991 | 1 | < 0.1% |
reach
Real number (ℝ)
High correlation 
| Distinct | 28036 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1054345.4 |
| Minimum | 20913 |
|---|---|
| Maximum | 1999865 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 20913 |
|---|---|
| 5-th percentile | 211500.25 |
| Q1 | 580626.5 |
| median | 1051291 |
| Q3 | 1525056.2 |
| 95-th percentile | 1908777.5 |
| Maximum | 1999865 |
| Range | 1978952 |
| Interquartile range (IQR) | 944429.75 |
Descriptive statistics
| Standard deviation | 545631.27 |
|---|---|
| Coefficient of variation (CV) | 0.51750713 |
| Kurtosis | -1.1863466 |
| Mean | 1054345.4 |
| Median Absolute Deviation (MAD) | 472670 |
| Skewness | 0.0033196577 |
| Sum | 2.9770497 × 1010 |
| Variance | 2.9771348 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 834459 | 3 | < 0.1% |
| 791989 | 2 | < 0.1% |
| 939058 | 2 | < 0.1% |
| 1621321 | 2 | < 0.1% |
| 1359807 | 2 | < 0.1% |
| 1611024 | 2 | < 0.1% |
| 145521 | 2 | < 0.1% |
| 961658 | 2 | < 0.1% |
| 1427413 | 2 | < 0.1% |
| 1944126 | 2 | < 0.1% |
| Other values (28026) | 28215 |
| Value | Count | Frequency (%) |
| 20913 | 1 | |
| 29995 | 1 | |
| 30314 | 1 | |
| 30608 | 1 | |
| 30615 | 1 | |
| 30902 | 1 | |
| 32483 | 1 | |
| 33270 | 1 | |
| 33274 | 1 | |
| 33541 | 1 |
| Value | Count | Frequency (%) |
| 1999865 | 1 | |
| 1999780 | 1 | |
| 1999750 | 1 | |
| 1999744 | 1 | |
| 1999631 | 1 | |
| 1999576 | 1 | |
| 1999543 | 1 | |
| 1999487 | 1 | |
| 1999431 | 1 | |
| 1999305 | 1 |
impressions
Real number (ℝ)
High correlation 
| Distinct | 28035 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1304714.6 |
| Minimum | 31181 |
|---|---|
| Maximum | 2497940 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 31181 |
|---|---|
| 5-th percentile | 415675.75 |
| Q1 | 832400.25 |
| median | 1299030.5 |
| Q3 | 1776869.2 |
| 95-th percentile | 2197843.8 |
| Maximum | 2497940 |
| Range | 2466759 |
| Interquartile range (IQR) | 944469 |
Descriptive statistics
| Standard deviation | 565667.54 |
|---|---|
| Coefficient of variation (CV) | 0.43355655 |
| Kurtosis | -1.0416471 |
| Mean | 1304714.6 |
| Median Absolute Deviation (MAD) | 472828 |
| Skewness | 0.006150288 |
| Sum | 3.683992 × 1010 |
| Variance | 3.1997977 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1589220 | 3 | < 0.1% |
| 840985 | 3 | < 0.1% |
| 1936727 | 3 | < 0.1% |
| 977749 | 3 | < 0.1% |
| 1340259 | 2 | < 0.1% |
| 1874618 | 2 | < 0.1% |
| 2047351 | 2 | < 0.1% |
| 2063355 | 2 | < 0.1% |
| 655946 | 2 | < 0.1% |
| 906928 | 2 | < 0.1% |
| Other values (28025) | 28212 |
| Value | Count | Frequency (%) |
| 31181 | 1 | |
| 43717 | 1 | |
| 48060 | 1 | |
| 73729 | 1 | |
| 75094 | 1 | |
| 78076 | 1 | |
| 81868 | 1 | |
| 86152 | 1 | |
| 87380 | 1 | |
| 92094 | 1 |
| Value | Count | Frequency (%) |
| 2497940 | 1 | |
| 2489252 | 1 | |
| 2485727 | 1 | |
| 2484270 | 1 | |
| 2482212 | 1 | |
| 2480980 | 1 | |
| 2477184 | 1 | |
| 2474793 | 1 | |
| 2473379 | 1 | |
| 2473253 | 1 |
caption_length
Real number (ℝ)
High correlation 
| Distinct | 2201 |
|---|---|
| Distinct (%) | 7.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1102.4585 |
| Minimum | 0 |
|---|---|
| Maximum | 2200 |
| Zeros | 15 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 107 |
| Q1 | 555 |
| median | 1099.5 |
| Q3 | 1655 |
| 95-th percentile | 2091 |
| Maximum | 2200 |
| Range | 2200 |
| Interquartile range (IQR) | 1100 |
Descriptive statistics
| Standard deviation | 635.53687 |
|---|---|
| Coefficient of variation (CV) | 0.5764724 |
| Kurtosis | -1.1989016 |
| Mean | 1102.4585 |
| Median Absolute Deviation (MAD) | 550.5 |
| Skewness | -0.0029517995 |
| Sum | 31129017 |
| Variance | 403907.12 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1787 | 28 | 0.1% |
| 1959 | 25 | 0.1% |
| 572 | 25 | 0.1% |
| 384 | 25 | 0.1% |
| 1673 | 25 | 0.1% |
| 76 | 24 | 0.1% |
| 449 | 24 | 0.1% |
| 1034 | 24 | 0.1% |
| 592 | 24 | 0.1% |
| 1122 | 23 | 0.1% |
| Other values (2191) | 27989 |
| Value | Count | Frequency (%) |
| 0 | 15 | |
| 1 | 14 | |
| 2 | 15 | |
| 3 | 16 | |
| 4 | 12 | |
| 5 | 9 | |
| 6 | 18 | |
| 7 | 11 | |
| 8 | 11 | |
| 9 | 9 |
| Value | Count | Frequency (%) |
| 2200 | 13 | |
| 2199 | 13 | |
| 2198 | 9 | |
| 2197 | 18 | |
| 2196 | 9 | |
| 2195 | 8 | |
| 2194 | 11 | |
| 2193 | 9 | |
| 2192 | 13 | |
| 2191 | 14 |
hashtags_count
Real number (ℝ)
High correlation  Zeros 
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.890849 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 957 |
| Zeros (%) | 3.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 7 |
| median | 15 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 9.001764 |
|---|---|
| Coefficient of variation (CV) | 0.60451652 |
| Kurtosis | -1.2158726 |
| Mean | 14.890849 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.018252039 |
| Sum | 420458 |
| Variance | 81.031755 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 25 | 966 | 3.4% |
| 0 | 957 | 3.4% |
| 29 | 953 | 3.4% |
| 5 | 950 | 3.4% |
| 1 | 942 | 3.3% |
| 6 | 936 | 3.3% |
| 2 | 936 | 3.3% |
| 28 | 936 | 3.3% |
| 22 | 934 | 3.3% |
| 3 | 928 | 3.3% |
| Other values (21) | 18798 |
| Value | Count | Frequency (%) |
| 0 | 957 | |
| 1 | 942 | |
| 2 | 936 | |
| 3 | 928 | |
| 4 | 917 | |
| 5 | 950 | |
| 6 | 936 | |
| 7 | 916 | |
| 8 | 917 | |
| 9 | 920 |
| Value | Count | Frequency (%) |
| 30 | 899 | |
| 29 | 953 | |
| 28 | 936 | |
| 27 | 878 | |
| 26 | 874 | |
| 25 | 966 | |
| 24 | 879 | |
| 23 | 867 | |
| 22 | 934 | |
| 21 | 829 |
followers_gained
Real number (ℝ)
| Distinct | 1001 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 501.66189 |
| Minimum | 0 |
|---|---|
| Maximum | 1000 |
| Zeros | 24 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 50 |
| Q1 | 250 |
| median | 500 |
| Q3 | 755 |
| 95-th percentile | 951 |
| Maximum | 1000 |
| Range | 1000 |
| Interquartile range (IQR) | 505 |
Descriptive statistics
| Standard deviation | 290.43177 |
|---|---|
| Coefficient of variation (CV) | 0.57893927 |
| Kurtosis | -1.2149113 |
| Mean | 501.66189 |
| Median Absolute Deviation (MAD) | 252.5 |
| Skewness | -0.0031426126 |
| Sum | 14164925 |
| Variance | 84350.611 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 752 | 46 | 0.2% |
| 398 | 46 | 0.2% |
| 138 | 44 | 0.2% |
| 470 | 43 | 0.2% |
| 328 | 43 | 0.2% |
| 841 | 43 | 0.2% |
| 951 | 43 | 0.2% |
| 667 | 43 | 0.2% |
| 918 | 43 | 0.2% |
| 985 | 42 | 0.1% |
| Other values (991) | 27800 |
| Value | Count | Frequency (%) |
| 0 | 24 | |
| 1 | 20 | |
| 2 | 26 | |
| 3 | 31 | |
| 4 | 29 | |
| 5 | 22 | |
| 6 | 23 | |
| 7 | 27 | |
| 8 | 34 | |
| 9 | 32 |
| Value | Count | Frequency (%) |
| 1000 | 29 | |
| 999 | 31 | |
| 998 | 26 | |
| 997 | 34 | |
| 996 | 29 | |
| 995 | 24 | |
| 994 | 30 | |
| 993 | 18 | |
| 992 | 35 | |
| 991 | 21 |
traffic_source
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Home Feed | |
|---|---|
| Hashtags | |
| Reels Feed | |
| External | |
| Profile |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.1758394 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Reels Feed |
|---|---|
| 2nd row | Hashtags |
| 3rd row | Hashtags |
| 4th row | Explore |
| 5th row | Profile |
Common Values
| Value | Count | Frequency (%) |
| Home Feed | 4773 | |
| Hashtags | 4752 | |
| Reels Feed | 4730 | |
| External | 4713 | |
| Profile | 4695 | |
| Explore | 4573 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| feed | 9503 | |
| home | 4773 | |
| hashtags | 4752 | |
| reels | 4730 | |
| external | 4713 | |
| profile | 4695 | |
| explore | 4573 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 47220 | |
| l | 18711 | 8.1% |
| s | 14234 | 6.2% |
| a | 14217 | 6.2% |
| o | 14041 | 6.1% |
| r | 13981 | 6.1% |
| H | 9525 | 4.1% |
| 9503 | 4.1% | |
| F | 9503 | 4.1% |
| d | 9503 | 4.1% |
| Other values (12) | 70415 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 183611 | |
| Uppercase Letter | 37739 | 16.3% |
| Space Separator | 9503 | 4.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 47220 | |
| l | 18711 | 10.2% |
| s | 14234 | 7.8% |
| a | 14217 | 7.7% |
| o | 14041 | 7.6% |
| r | 13981 | 7.6% |
| d | 9503 | 5.2% |
| t | 9465 | 5.2% |
| x | 9286 | 5.1% |
| m | 4773 | 2.6% |
| Other values (6) | 28180 |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 9525 | |
| F | 9503 | |
| E | 9286 | |
| R | 4730 | |
| P | 4695 |
Space Separator
| Value | Count | Frequency (%) |
| 9503 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 221350 | |
| Common | 9503 | 4.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 47220 | |
| l | 18711 | 8.5% |
| s | 14234 | 6.4% |
| a | 14217 | 6.4% |
| o | 14041 | 6.3% |
| r | 13981 | 6.3% |
| H | 9525 | 4.3% |
| F | 9503 | 4.3% |
| d | 9503 | 4.3% |
| t | 9465 | 4.3% |
| Other values (11) | 60950 |
Common
| Value | Count | Frequency (%) |
| 9503 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 230853 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 47220 | |
| l | 18711 | 8.1% |
| s | 14234 | 6.2% |
| a | 14217 | 6.2% |
| o | 14041 | 6.1% |
| r | 13981 | 6.1% |
| H | 9525 | 4.1% |
| 9503 | 4.1% | |
| F | 9503 | 4.1% |
| d | 9503 | 4.1% |
| Other values (12) | 70415 |
content_category
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| Fashion | |
|---|---|
| Technology | |
| Food | |
| Photography | |
| Lifestyle | |
| Other values (5) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.108089 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Technology |
|---|---|
| 2nd row | Photography |
| 3rd row | Fashion |
| 4th row | Technology |
| 5th row | Photography |
Common Values
| Value | Count | Frequency (%) |
| Fashion | 2871 | |
| Technology | 2860 | |
| Food | 2842 | |
| Photography | 2837 | |
| Lifestyle | 2830 | |
| Music | 2825 | |
| Fitness | 2811 | |
| Travel | 2807 | |
| Comedy | 2780 | |
| Beauty | 2773 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| fashion | 2871 | |
| technology | 2860 | |
| food | 2842 | |
| photography | 2837 | |
| lifestyle | 2830 | |
| music | 2825 | |
| fitness | 2811 | |
| travel | 2807 | |
| comedy | 2780 | |
| beauty | 2773 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 22729 | 11.3% |
| e | 19691 | 9.8% |
| s | 14148 | 7.0% |
| y | 14080 | 7.0% |
| h | 11405 | 5.7% |
| i | 11337 | 5.6% |
| a | 11288 | 5.6% |
| t | 11251 | 5.6% |
| n | 8542 | 4.3% |
| F | 8524 | 4.2% |
| Other values (16) | 67709 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 172468 | |
| Uppercase Letter | 28236 | 14.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 22729 | |
| e | 19691 | |
| s | 14148 | 8.2% |
| y | 14080 | 8.2% |
| h | 11405 | 6.6% |
| i | 11337 | 6.6% |
| a | 11288 | 6.5% |
| t | 11251 | 6.5% |
| n | 8542 | 5.0% |
| l | 8497 | 4.9% |
| Other values (9) | 39500 |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 8524 | |
| T | 5667 | |
| P | 2837 | 10.0% |
| L | 2830 | 10.0% |
| M | 2825 | 10.0% |
| C | 2780 | 9.8% |
| B | 2773 | 9.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 200704 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 22729 | 11.3% |
| e | 19691 | 9.8% |
| s | 14148 | 7.0% |
| y | 14080 | 7.0% |
| h | 11405 | 5.7% |
| i | 11337 | 5.6% |
| a | 11288 | 5.6% |
| t | 11251 | 5.6% |
| n | 8542 | 4.3% |
| F | 8524 | 4.2% |
| Other values (16) | 67709 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 200704 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 22729 | 11.3% |
| e | 19691 | 9.8% |
| s | 14148 | 7.0% |
| y | 14080 | 7.0% |
| h | 11405 | 5.7% |
| i | 11337 | 5.6% |
| a | 11288 | 5.6% |
| t | 11251 | 5.6% |
| n | 8542 | 4.3% |
| F | 8524 | 4.2% |
| Other values (16) | 67709 |
account_id
Text
| Distinct | 300 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | creator_135 |
|---|---|
| 2nd row | creator_109 |
| 3rd row | creator_135 |
| 4th row | creator_271 |
| 5th row | creator_223 |
| Value | Count | Frequency (%) |
| creator_152 | 114 | 0.4% |
| creator_076 | 114 | 0.4% |
| creator_267 | 114 | 0.4% |
| creator_195 | 113 | 0.4% |
| creator_171 | 113 | 0.4% |
| creator_020 | 113 | 0.4% |
| creator_120 | 113 | 0.4% |
| creator_013 | 113 | 0.4% |
| creator_223 | 113 | 0.4% |
| creator_164 | 112 | 0.4% |
| Other values (290) | 27104 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 56472 | |
| c | 28236 | |
| e | 28236 | |
| a | 28236 | |
| t | 28236 | |
| o | 28236 | |
| _ | 28236 | |
| 2 | 15325 | 4.9% |
| 1 | 15111 | 4.9% |
| 0 | 14862 | 4.8% |
| Other values (7) | 39410 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 197652 | |
| Decimal Number | 84708 | |
| Connector Punctuation | 28236 | 9.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 15325 | |
| 1 | 15111 | |
| 0 | 14862 | |
| 3 | 5737 | 6.8% |
| 9 | 5709 | 6.7% |
| 6 | 5667 | 6.7% |
| 5 | 5644 | 6.7% |
| 8 | 5630 | 6.6% |
| 7 | 5520 | 6.5% |
| 4 | 5503 | 6.5% |
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 56472 | |
| c | 28236 | |
| e | 28236 | |
| a | 28236 | |
| t | 28236 | |
| o | 28236 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 28236 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 197652 | |
| Common | 112944 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| _ | 28236 | |
| 2 | 15325 | |
| 1 | 15111 | |
| 0 | 14862 | |
| 3 | 5737 | 5.1% |
| 9 | 5709 | 5.1% |
| 6 | 5667 | 5.0% |
| 5 | 5644 | 5.0% |
| 8 | 5630 | 5.0% |
| 7 | 5520 | 4.9% |
Latin
| Value | Count | Frequency (%) |
| r | 56472 | |
| c | 28236 | |
| e | 28236 | |
| a | 28236 | |
| t | 28236 | |
| o | 28236 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 310596 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 56472 | |
| c | 28236 | |
| e | 28236 | |
| a | 28236 | |
| t | 28236 | |
| o | 28236 | |
| _ | 28236 | |
| 2 | 15325 | 4.9% |
| 1 | 15111 | 4.9% |
| 0 | 14862 | 4.8% |
| Other values (7) | 39410 |
followers_count_before_post
Real number (ℝ)
High correlation 
| Distinct | 24347 |
|---|---|
| Distinct (%) | 86.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54126.576 |
| Minimum | 5000 |
|---|---|
| Maximum | 165591 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 5000 |
|---|---|
| 5-th percentile | 12391.75 |
| Q1 | 30672.75 |
| median | 46936.5 |
| Q3 | 68475.25 |
| 95-th percentile | 126044 |
| Maximum | 165591 |
| Range | 160591 |
| Interquartile range (IQR) | 37802.5 |
Descriptive statistics
| Standard deviation | 33246.39 |
|---|---|
| Coefficient of variation (CV) | 0.61423413 |
| Kurtosis | 0.47962318 |
| Mean | 54126.576 |
| Median Absolute Deviation (MAD) | 18272 |
| Skewness | 1.0013824 |
| Sum | 1.528318 × 109 |
| Variance | 1.1053225 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5000 | 90 | 0.3% |
| 15000 | 65 | 0.2% |
| 30000 | 62 | 0.2% |
| 60000 | 30 | 0.1% |
| 100000 | 28 | 0.1% |
| 38893 | 4 | < 0.1% |
| 51053 | 4 | < 0.1% |
| 43790 | 4 | < 0.1% |
| 54526 | 4 | < 0.1% |
| 35347 | 4 | < 0.1% |
| Other values (24337) | 27941 |
| Value | Count | Frequency (%) |
| 5000 | 90 | |
| 5007 | 1 | < 0.1% |
| 5011 | 1 | < 0.1% |
| 5012 | 1 | < 0.1% |
| 5013 | 1 | < 0.1% |
| 5018 | 1 | < 0.1% |
| 5031 | 1 | < 0.1% |
| 5037 | 1 | < 0.1% |
| 5047 | 1 | < 0.1% |
| 5074 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 165591 | 1 | |
| 165070 | 1 | |
| 165000 | 1 | |
| 164652 | 1 | |
| 163712 | 1 | |
| 162919 | 1 | |
| 162663 | 1 | |
| 162516 | 1 | |
| 162038 | 1 | |
| 161384 | 1 |
engagement_rate
Real number (ℝ)
High correlation 
| Distinct | 27954 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.2793771 |
| Minimum | 0.055498861 |
|---|---|
| Maximum | 21.070199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 0.055498861 |
|---|---|
| 5-th percentile | 0.40863036 |
| Q1 | 1.1629225 |
| median | 2.2162619 |
| Q3 | 3.9690757 |
| 95-th percentile | 10.026687 |
| Maximum | 21.070199 |
| Range | 21.0147 |
| Interquartile range (IQR) | 2.8061531 |
Descriptive statistics
| Standard deviation | 3.5170442 |
|---|---|
| Coefficient of variation (CV) | 1.0724732 |
| Kurtosis | 9.0744043 |
| Mean | 3.2793771 |
| Median Absolute Deviation (MAD) | 1.2490315 |
| Skewness | 2.7353563 |
| Sum | 92596.493 |
| Variance | 12.3696 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 21.07019931 | 283 | 1.0% |
| 2.698758164 | 1 | < 0.1% |
| 2.21431915 | 1 | < 0.1% |
| 3.031728835 | 1 | < 0.1% |
| 1.6501105 | 1 | < 0.1% |
| 1.415171879 | 1 | < 0.1% |
| 1.949481701 | 1 | < 0.1% |
| 1.838752047 | 1 | < 0.1% |
| 0.551111048 | 1 | < 0.1% |
| 0.7748799596 | 1 | < 0.1% |
| Other values (27944) | 27944 |
| Value | Count | Frequency (%) |
| 0.05549886118 | 1 | |
| 0.05844464515 | 1 | |
| 0.06048152056 | 1 | |
| 0.06680675873 | 1 | |
| 0.06720189688 | 1 | |
| 0.07165568495 | 1 | |
| 0.0765918876 | 1 | |
| 0.07785253064 | 1 | |
| 0.08109450438 | 1 | |
| 0.08206871434 | 1 |
| Value | Count | Frequency (%) |
| 21.07019931 | 283 | |
| 21.0685624 | 1 | < 0.1% |
| 21.05404384 | 1 | < 0.1% |
| 21.05316995 | 1 | < 0.1% |
| 21.02699773 | 1 | < 0.1% |
| 21.02656546 | 1 | < 0.1% |
| 21.00823402 | 1 | < 0.1% |
| 21.00453878 | 1 | < 0.1% |
| 20.95667082 | 1 | < 0.1% |
| 20.9330855 | 1 | < 0.1% |
post_hour
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.6 MiB |
| 9 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9 |
|---|---|
| 2nd row | 9 |
| 3rd row | 9 |
| 4th row | 9 |
| 5th row | 9 |
Common Values
| Value | Count | Frequency (%) |
| 9 | 28236 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 9 | 28236 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 28236 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 28236 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 28236 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 28236 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 28236 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28236 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 28236 |
post_day
Categorical
High correlation 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| Thursday | |
|---|---|
| Tuesday | |
| Wednesday | |
| Monday | |
| Saturday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 7.1509775 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Friday |
|---|---|
| 2nd row | Saturday |
| 3rd row | Friday |
| 4th row | Thursday |
| 5th row | Friday |
Common Values
| Value | Count | Frequency (%) |
| Thursday | 4103 | |
| Tuesday | 4102 | |
| Wednesday | 4069 | |
| Monday | 4041 | |
| Saturday | 3992 | |
| Sunday | 3970 | |
| Friday | 3959 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| thursday | 4103 | |
| tuesday | 4102 | |
| wednesday | 4069 | |
| monday | 4041 | |
| saturday | 3992 | |
| sunday | 3970 | |
| friday | 3959 |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 32305 | |
| a | 32228 | |
| y | 28236 | |
| u | 16167 | |
| s | 12274 | 6.1% |
| e | 12240 | 6.1% |
| n | 12080 | 6.0% |
| r | 12054 | 6.0% |
| T | 8205 | 4.1% |
| S | 7962 | 3.9% |
| Other values (7) | 28164 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 173679 | |
| Uppercase Letter | 28236 | 14.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 32305 | |
| a | 32228 | |
| y | 28236 | |
| u | 16167 | |
| s | 12274 | 7.1% |
| e | 12240 | 7.0% |
| n | 12080 | 7.0% |
| r | 12054 | 6.9% |
| h | 4103 | 2.4% |
| o | 4041 | 2.3% |
| Other values (2) | 7951 | 4.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 8205 | |
| S | 7962 | |
| W | 4069 | |
| M | 4041 | |
| F | 3959 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 201915 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| d | 32305 | |
| a | 32228 | |
| y | 28236 | |
| u | 16167 | |
| s | 12274 | 6.1% |
| e | 12240 | 6.1% |
| n | 12080 | 6.0% |
| r | 12054 | 6.0% |
| T | 8205 | 4.1% |
| S | 7962 | 3.9% |
| Other values (7) | 28164 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 201915 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| d | 32305 | |
| a | 32228 | |
| y | 28236 | |
| u | 16167 | |
| s | 12274 | 6.1% |
| e | 12240 | 6.1% |
| n | 12080 | 6.0% |
| r | 12054 | 6.0% |
| T | 8205 | 4.1% |
| S | 7962 | 3.9% |
| Other values (7) | 28164 |
is_weekend
Boolean
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.2 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 20274 | |
| True | 7962 | 28.2% |
has_high_hashtags
Boolean
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.2 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 18917 | |
| False | 9319 |
long_caption
Boolean
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.2 KiB |
| True | |
|---|---|
| False | 1937 |
| Value | Count | Frequency (%) |
| True | 26299 | |
| False | 1937 | 6.9% |
high_intent_engagement
Real number (ℝ)
High correlation 
| Distinct | 13962 |
|---|---|
| Distinct (%) | 49.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9977.1642 |
| Minimum | 124 |
|---|---|
| Maximum | 19965 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 441.2 KiB |
Quantile statistics
| Minimum | 124 |
|---|---|
| 5-th percentile | 2676 |
| Q1 | 6134.75 |
| median | 9993.5 |
| Q3 | 13751.5 |
| 95-th percentile | 17299.25 |
| Maximum | 19965 |
| Range | 19841 |
| Interquartile range (IQR) | 7616.75 |
Descriptive statistics
| Standard deviation | 4595.4393 |
|---|---|
| Coefficient of variation (CV) | 0.46059574 |
| Kurtosis | -0.99778728 |
| Mean | 9977.1642 |
| Median Absolute Deviation (MAD) | 3800.5 |
| Skewness | 0.0063425592 |
| Sum | 2.8171521 × 108 |
| Variance | 21118063 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11582 | 9 | < 0.1% |
| 14476 | 9 | < 0.1% |
| 8893 | 9 | < 0.1% |
| 5451 | 8 | < 0.1% |
| 8496 | 8 | < 0.1% |
| 10479 | 8 | < 0.1% |
| 12395 | 8 | < 0.1% |
| 15735 | 8 | < 0.1% |
| 6581 | 8 | < 0.1% |
| 10144 | 7 | < 0.1% |
| Other values (13952) | 28154 |
| Value | Count | Frequency (%) |
| 124 | 1 | |
| 131 | 1 | |
| 138 | 1 | |
| 139 | 1 | |
| 178 | 1 | |
| 180 | 1 | |
| 189 | 1 | |
| 199 | 1 | |
| 200 | 1 | |
| 253 | 1 |
| Value | Count | Frequency (%) |
| 19965 | 1 | |
| 19933 | 1 | |
| 19925 | 1 | |
| 19881 | 1 | |
| 19872 | 1 | |
| 19842 | 1 | |
| 19808 | 1 | |
| 19800 | 1 | |
| 19792 | 1 | |
| 19781 | 1 |
follower_bucket
Categorical
High correlation  Uniform 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.6 KiB |
| Small | |
|---|---|
| Medium | |
| Large | |
| Very Large |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 6.5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Large |
|---|---|
| 2nd row | Small |
| 3rd row | Very Large |
| 4th row | Very Large |
| 5th row | Very Large |
Common Values
| Value | Count | Frequency (%) |
| Small | 7059 | |
| Medium | 7059 | |
| Large | 7059 | |
| Very Large | 7059 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| large | 14118 | |
| small | 7059 | |
| medium | 7059 | |
| very | 7059 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 28236 | |
| a | 21177 | |
| r | 21177 | |
| m | 14118 | 7.7% |
| l | 14118 | 7.7% |
| L | 14118 | 7.7% |
| g | 14118 | 7.7% |
| S | 7059 | 3.8% |
| M | 7059 | 3.8% |
| d | 7059 | 3.8% |
| Other values (5) | 35295 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 141180 | |
| Uppercase Letter | 35295 | 19.2% |
| Space Separator | 7059 | 3.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 28236 | |
| a | 21177 | |
| r | 21177 | |
| m | 14118 | |
| l | 14118 | |
| g | 14118 | |
| d | 7059 | 5.0% |
| i | 7059 | 5.0% |
| u | 7059 | 5.0% |
| y | 7059 | 5.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 14118 | |
| S | 7059 | |
| M | 7059 | |
| V | 7059 |
Space Separator
| Value | Count | Frequency (%) |
| 7059 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 176475 | |
| Common | 7059 | 3.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 28236 | |
| a | 21177 | |
| r | 21177 | |
| m | 14118 | |
| l | 14118 | |
| L | 14118 | |
| g | 14118 | |
| S | 7059 | 4.0% |
| M | 7059 | 4.0% |
| d | 7059 | 4.0% |
| Other values (4) | 28236 |
Common
| Value | Count | Frequency (%) |
| 7059 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 183534 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 28236 | |
| a | 21177 | |
| r | 21177 | |
| m | 14118 | 7.7% |
| l | 14118 | 7.7% |
| L | 14118 | 7.7% |
| g | 14118 | 7.7% |
| S | 7059 | 3.8% |
| M | 7059 | 3.8% |
| d | 7059 | 3.8% |
| Other values (5) | 35295 |
Interactions
Correlations
| caption_length | comments | content_category | engagement_rate | follower_bucket | followers_count_before_post | followers_gained | has_high_hashtags | hashtags_count | high_intent_engagement | impressions | is_weekend | likes | long_caption | media_type | post_day | reach | saves | shares | traffic_source | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| caption_length | 1.000 | -0.009 | 0.005 | -0.002 | 0.008 | 0.002 | -0.002 | 0.000 | 0.004 | 0.010 | -0.006 | 0.008 | 0.001 | 0.809 | 0.000 | 0.000 | -0.005 | 0.010 | 0.003 | 0.000 |
| comments | -0.009 | 1.000 | 0.003 | 0.032 | 0.000 | 0.005 | 0.002 | 0.006 | 0.008 | -0.004 | 0.002 | 0.000 | -0.002 | 0.012 | 0.012 | 0.000 | -0.000 | -0.004 | -0.006 | 0.000 |
| content_category | 0.005 | 0.003 | 1.000 | 0.000 | 0.000 | 0.004 | 0.006 | 0.014 | 0.007 | 0.000 | 0.009 | 0.008 | 0.004 | 0.016 | 0.008 | 0.000 | 0.008 | 0.007 | 0.000 | 0.004 |
| engagement_rate | -0.002 | 0.032 | 0.000 | 1.000 | 0.466 | -0.689 | 0.001 | 0.003 | -0.004 | 0.061 | 0.036 | 0.000 | 0.671 | 0.000 | 0.000 | 0.000 | 0.040 | 0.057 | 0.026 | 0.000 |
| follower_bucket | 0.008 | 0.000 | 0.000 | 0.466 | 1.000 | 0.834 | 0.008 | 0.006 | 0.011 | 0.006 | 0.000 | 0.000 | 0.000 | 0.003 | 0.005 | 0.000 | 0.000 | 0.007 | 0.000 | 0.000 |
| followers_count_before_post | 0.002 | 0.005 | 0.004 | -0.689 | 0.834 | 1.000 | -0.005 | 0.000 | 0.004 | -0.008 | -0.002 | 0.007 | 0.001 | 0.000 | 0.000 | 0.004 | -0.003 | -0.008 | -0.004 | 0.010 |
| followers_gained | -0.002 | 0.002 | 0.006 | 0.001 | 0.008 | -0.005 | 1.000 | 0.004 | 0.008 | 0.002 | -0.000 | 0.008 | -0.006 | 0.002 | 0.001 | 0.000 | 0.000 | 0.000 | 0.005 | 0.009 |
| has_high_hashtags | 0.000 | 0.006 | 0.014 | 0.003 | 0.006 | 0.000 | 0.004 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.009 |
| hashtags_count | 0.004 | 0.008 | 0.007 | -0.004 | 0.011 | 0.004 | 0.008 | 1.000 | 1.000 | -0.003 | -0.004 | 0.002 | -0.001 | 0.000 | 0.000 | 0.009 | -0.006 | -0.001 | -0.005 | 0.000 |
| high_intent_engagement | 0.010 | -0.004 | 0.000 | 0.061 | 0.006 | -0.008 | 0.002 | 0.000 | -0.003 | 1.000 | 0.005 | 0.000 | -0.001 | 0.000 | 0.006 | 0.007 | 0.005 | 0.952 | 0.304 | 0.000 |
| impressions | -0.006 | 0.002 | 0.009 | 0.036 | 0.000 | -0.002 | -0.000 | 0.000 | -0.004 | 0.005 | 1.000 | 0.009 | 0.049 | 0.008 | 0.000 | 0.008 | 0.969 | 0.008 | -0.008 | 0.000 |
| is_weekend | 0.008 | 0.000 | 0.008 | 0.000 | 0.000 | 0.007 | 0.008 | 0.000 | 0.002 | 0.000 | 0.009 | 1.000 | 0.008 | 0.000 | 0.000 | 1.000 | 0.000 | 0.004 | 0.000 | 0.000 |
| likes | 0.001 | -0.002 | 0.004 | 0.671 | 0.000 | 0.001 | -0.006 | 0.000 | -0.001 | -0.001 | 0.049 | 0.008 | 1.000 | 0.000 | 0.000 | 0.003 | 0.054 | -0.003 | 0.006 | 0.000 |
| long_caption | 0.809 | 0.012 | 0.016 | 0.000 | 0.003 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.008 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.004 | 0.018 | 0.000 | 0.000 |
| media_type | 0.000 | 0.012 | 0.008 | 0.000 | 0.005 | 0.000 | 0.001 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.011 | 0.000 | 0.000 | 0.002 |
| post_day | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.009 | 0.007 | 0.008 | 1.000 | 0.003 | 0.000 | 0.000 | 1.000 | 0.007 | 0.007 | 0.000 | 0.000 |
| reach | -0.005 | -0.000 | 0.008 | 0.040 | 0.000 | -0.003 | 0.000 | 0.000 | -0.006 | 0.005 | 0.969 | 0.000 | 0.054 | 0.004 | 0.011 | 0.007 | 1.000 | 0.007 | -0.006 | 0.000 |
| saves | 0.010 | -0.004 | 0.007 | 0.057 | 0.007 | -0.008 | 0.000 | 0.000 | -0.001 | 0.952 | 0.008 | 0.004 | -0.003 | 0.018 | 0.000 | 0.007 | 0.007 | 1.000 | 0.005 | 0.000 |
| shares | 0.003 | -0.006 | 0.000 | 0.026 | 0.000 | -0.004 | 0.005 | 0.000 | -0.005 | 0.304 | -0.008 | 0.000 | 0.006 | 0.000 | 0.000 | 0.000 | -0.006 | 0.005 | 1.000 | 0.000 |
| traffic_source | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.010 | 0.009 | 0.009 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
Missing values
Sample
| post_id | upload_date | media_type | likes | comments | shares | saves | reach | impressions | caption_length | hashtags_count | followers_gained | traffic_source | content_category | account_id | followers_count_before_post | engagement_rate | post_hour | post_day | is_weekend | has_high_hashtags | long_caption | high_intent_engagement | follower_bucket | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | IG0013402 | 2025-04-04 09:25:22.954916 | Reel | 132420 | 5003 | 3667 | 5601 | 1546640 | 2016802 | 1750 | 6 | 171 | Reels Feed | Technology | creator_135 | 54355 | 2.698758 | 9 | Friday | False | False | True | 9268 | Large |
| 2 | IG0010751 | 2025-04-19 09:25:22.954916 | Video | 31476 | 6754 | 4382 | 12891 | 1916933 | 2079234 | 1502 | 26 | 892 | Hashtags | Photography | creator_109 | 26763 | 2.073871 | 9 | Saturday | True | True | True | 17273 | Small |
| 3 | IG0013361 | 2025-08-15 09:25:22.954916 | Video | 94556 | 9750 | 1667 | 10965 | 1451049 | 1816268 | 626 | 27 | 530 | Hashtags | Fashion | creator_135 | 71457 | 1.636481 | 9 | Friday | False | True | True | 12632 | Very Large |
| 4 | IG0027034 | 2025-02-27 09:25:22.954916 | Video | 38105 | 1743 | 4306 | 2341 | 1240598 | 1707533 | 1131 | 16 | 289 | Explore | Technology | creator_271 | 119968 | 0.387562 | 9 | Thursday | False | True | True | 6647 | Very Large |
| 5 | IG0022212 | 2025-09-05 09:25:22.954916 | Carousel | 113141 | 9477 | 3079 | 310 | 496673 | 690055 | 26 | 4 | 604 | Profile | Photography | creator_223 | 76806 | 1.640588 | 9 | Friday | False | False | False | 3389 | Very Large |
| 6 | IG0027062 | 2024-11-25 09:25:22.954916 | Video | 39301 | 9597 | 763 | 369 | 222449 | 692071 | 447 | 25 | 295 | Reels Feed | Photography | creator_271 | 102513 | 0.488036 | 9 | Monday | False | True | True | 1132 | Very Large |
| 8 | IG0021589 | 2025-09-03 09:25:22.954916 | Photo | 60627 | 2747 | 3371 | 4244 | 841674 | 860179 | 1397 | 12 | 550 | External | Technology | creator_218 | 78277 | 0.906895 | 9 | Wednesday | False | True | True | 7615 | Very Large |
| 9 | IG0012768 | 2025-03-30 09:25:22.954916 | Video | 171776 | 8005 | 3337 | 837 | 1637998 | 2055998 | 837 | 12 | 16 | Home Feed | Fitness | creator_129 | 27157 | 6.773760 | 9 | Sunday | True | True | True | 4174 | Small |
| 10 | IG0000281 | 2024-11-20 09:25:22.954916 | Reel | 198491 | 9045 | 3079 | 2494 | 867699 | 1035039 | 697 | 2 | 59 | Home Feed | Lifestyle | creator_003 | 60237 | 3.537842 | 9 | Wednesday | False | False | True | 5573 | Large |
| 11 | IG0013175 | 2025-08-29 09:25:22.954916 | Reel | 148808 | 9378 | 2526 | 3553 | 667898 | 769902 | 42 | 9 | 229 | Hashtags | Beauty | creator_133 | 66403 | 2.473759 | 9 | Friday | False | False | False | 6079 | Large |
| post_id | upload_date | media_type | likes | comments | shares | saves | reach | impressions | caption_length | hashtags_count | followers_gained | traffic_source | content_category | account_id | followers_count_before_post | engagement_rate | post_hour | post_day | is_weekend | has_high_hashtags | long_caption | high_intent_engagement | follower_bucket | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29989 | IG0028299 | 2025-02-11 09:25:22.954916 | Photo | 188915 | 9134 | 1882 | 12575 | 1802319 | 2192918 | 564 | 22 | 263 | Home Feed | Technology | creator_284 | 43076 | 4.933281 | 9 | Tuesday | False | True | True | 14457 | Medium |
| 29990 | IG0013601 | 2025-09-30 09:25:22.954916 | Reel | 127391 | 6906 | 1700 | 8309 | 1004168 | 1084976 | 992 | 18 | 124 | External | Travel | creator_137 | 84575 | 1.706249 | 9 | Tuesday | False | True | True | 10009 | Very Large |
| 29991 | IG0029852 | 2025-02-14 09:25:22.954916 | Reel | 59163 | 1247 | 4164 | 766 | 601563 | 1002391 | 121 | 0 | 732 | Explore | Food | creator_299 | 18341 | 3.562510 | 9 | Friday | False | False | False | 4930 | Small |
| 29992 | IG0008746 | 2025-11-19 09:25:22.954916 | Reel | 50519 | 2735 | 3583 | 7246 | 1792483 | 2024162 | 2112 | 1 | 737 | Explore | Fashion | creator_090 | 90126 | 0.711038 | 9 | Wednesday | False | False | True | 10829 | Very Large |
| 29993 | IG0023022 | 2025-11-17 09:25:22.954916 | Reel | 179400 | 811 | 1945 | 2002 | 1579492 | 1801785 | 176 | 13 | 51 | Home Feed | Comedy | creator_231 | 158125 | 1.164636 | 9 | Monday | False | True | True | 3947 | Very Large |
| 29994 | IG0019653 | 2024-12-12 09:25:22.954916 | Carousel | 137702 | 6968 | 2848 | 3634 | 1447382 | 1873828 | 271 | 16 | 430 | Reels Feed | Fashion | creator_198 | 65898 | 2.293727 | 9 | Thursday | False | True | True | 6482 | Large |
| 29995 | IG0013079 | 2024-12-12 09:25:22.954916 | Carousel | 150118 | 6943 | 108 | 4787 | 977351 | 1229434 | 1506 | 18 | 300 | External | Beauty | creator_132 | 9902 | 16.355888 | 9 | Thursday | False | True | True | 4895 | Small |
| 29996 | IG0001698 | 2025-07-21 09:25:22.954916 | Reel | 66131 | 2789 | 2410 | 6048 | 1090867 | 1561926 | 1956 | 25 | 178 | Explore | Fitness | creator_017 | 85014 | 0.910179 | 9 | Monday | False | True | True | 8458 | Very Large |
| 29997 | IG0010959 | 2025-03-19 09:25:22.954916 | Reel | 81369 | 7822 | 552 | 14862 | 449706 | 850597 | 85 | 19 | 78 | Reels Feed | Food | creator_111 | 26057 | 4.014468 | 9 | Wednesday | False | True | False | 15414 | Small |
| 29998 | IG0024084 | 2025-10-07 09:25:22.954916 | Video | 75694 | 8697 | 2485 | 6541 | 402361 | 644327 | 1323 | 26 | 960 | Reels Feed | Travel | creator_242 | 59044 | 1.582159 | 9 | Tuesday | False | True | True | 9026 | Large |